﻿<SqlLoadGen worker="5" timeOut="10">
  <Database name="Adv" connectionStringKey="AdventureWorks">
    <Task name="0" percentage="50" transaction="Disabled">
      <Job name="Insert_temployee" type="SP" query="dbo.sp_tEmployee_insert" dataSource="Insert_temployee.csv">
        <Parameter name="@EmpID" type="Int" dataSourceKey="autogen" />
        <Parameter name="@FirstName" type="NVarChar" dataSourceKey="FirstName" />
        <Parameter name="@LastName" type="NVarChar" dataSourceKey="LastName" />
        <Parameter name="@HireDate" type="DateTime" dataSourceKey="HireDate" />
        <Parameter name="@Image" type="Image" dataSourceKey="Image" />
        <Parameter name="@married" type="Bit" dataSourceKey="married" />
      </Job>
    </Task>
    <Task name="1" percentage="50" transaction="Disabled">
      <Job name="select_vtemployee" type="Text" query="select * from [HumanResources].[vEmployee] where BusinessEntityID = @ID" dataSource="select_vemployee.csv">
        <Parameter name="@ID" type="Int" dataSourceKey="ID" />
      </Job>
    </Task>
  </Database>
</SqlLoadGen>